Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 89303 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 12.9 MiB |
| Average record size in memory | 151.7 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 5 |
IND_ESTADO_INACTIVA has constant value "0" | Constant |
CNT_CUENTAS_DISTINTAS is highly imbalanced (97.0%) | Imbalance |
IND_DEBAJO_UMBRAL_15K is highly imbalanced (78.1%) | Imbalance |
IND_SUP_15K is highly imbalanced (97.5%) | Imbalance |
CNT_CAJEROS_DISTINTOS is highly imbalanced (81.6%) | Imbalance |
PORC_RETIRO is highly skewed (γ1 = 53.04606165) | Skewed |
NUM_AUTORIZACION_TC has unique values | Unique |
Reproduction
| Analysis started | 2023-04-08 22:06:56.836514 |
|---|---|
| Analysis finished | 2023-04-08 22:07:20.909234 |
| Duration | 24.07 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
NUM_AUTORIZACION_TC
Real number (ℝ)
| Distinct | 89303 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 419200.1 |
| Minimum | 10 |
|---|---|
| Maximum | 804810 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 44040.8 |
| Q1 | 218692.5 |
| median | 429671 |
| Q3 | 619740 |
| 95-th percentile | 767336.6 |
| Maximum | 804810 |
| Range | 804800 |
| Interquartile range (IQR) | 401047.5 |
Descriptive statistics
| Standard deviation | 231515.28 |
|---|---|
| Coefficient of variation (CV) | 0.55227869 |
| Kurtosis | -1.1826363 |
| Mean | 419200.1 |
| Median Absolute Deviation (MAD) | 199291 |
| Skewness | -0.10042827 |
| Sum | 3.7435826 × 1010 |
| Variance | 5.3599326 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 543641 | 1 | < 0.1% |
| 727480 | 1 | < 0.1% |
| 497570 | 1 | < 0.1% |
| 65479 | 1 | < 0.1% |
| 71236 | 1 | < 0.1% |
| 727630 | 1 | < 0.1% |
| 35762 | 1 | < 0.1% |
| 189170 | 1 | < 0.1% |
| 59901 | 1 | < 0.1% |
| 47549 | 1 | < 0.1% |
| Other values (89293) | 89293 |
| Value | Count | Frequency (%) |
| 10 | 1 | |
| 11 | 1 | |
| 21 | 1 | |
| 38 | 1 | |
| 39 | 1 | |
| 40 | 1 | |
| 54 | 1 | |
| 61 | 1 | |
| 69 | 1 | |
| 72 | 1 |
| Value | Count | Frequency (%) |
| 804810 | 1 | |
| 804805 | 1 | |
| 804797 | 1 | |
| 804795 | 1 | |
| 804783 | 1 | |
| 804781 | 1 | |
| 804779 | 1 | |
| 804754 | 1 | |
| 804753 | 1 | |
| 804751 | 1 |
MON_MOVIMIENTO_QUETZALIZADO
Real number (ℝ)
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 440.0295 |
| Minimum | 50 |
|---|---|
| Maximum | 7435.98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 100 |
| median | 300 |
| Q3 | 500 |
| 95-th percentile | 1500 |
| Maximum | 7435.98 |
| Range | 7385.98 |
| Interquartile range (IQR) | 400 |
Descriptive statistics
| Standard deviation | 472.25584 |
|---|---|
| Coefficient of variation (CV) | 1.0732368 |
| Kurtosis | 8.4472849 |
| Mean | 440.0295 |
| Median Absolute Deviation (MAD) | 200 |
| Skewness | 2.3799307 |
| Sum | 39295954 |
| Variance | 223025.58 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 26688 | |
| 200 | 17271 | |
| 300 | 11532 | |
| 500 | 11365 | |
| 1000 | 9116 | 10.2% |
| 2000 | 2749 | 3.1% |
| 400 | 2495 | 2.8% |
| 600 | 1497 | 1.7% |
| 700 | 1175 | 1.3% |
| 800 | 1035 | 1.2% |
| Other values (320) | 4380 | 4.9% |
| Value | Count | Frequency (%) |
| 50 | 294 | 0.3% |
| 82.25 | 1 | < 0.1% |
| 100 | 26688 | |
| 112.67 | 1 | < 0.1% |
| 113.24 | 1 | < 0.1% |
| 114 | 2 | < 0.1% |
| 114.39 | 1 | < 0.1% |
| 114.55 | 2 | < 0.1% |
| 115.57 | 1 | < 0.1% |
| 116.19 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7435.98 | 1 | |
| 7304.58 | 1 | |
| 4632.84 | 1 | |
| 4621.1 | 1 | |
| 4618.18 | 1 | |
| 4617.55 | 1 | |
| 4609.27 | 1 | |
| 4593.54 | 1 | |
| 4568.4 | 1 | |
| 4557.33 | 1 |
NUM_CTA_DEB
Real number (ℝ)
| Distinct | 1687 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29392.301 |
| Minimum | 82 |
|---|---|
| Maximum | 47919 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 82 |
|---|---|
| 5-th percentile | 3321 |
| Q1 | 22245 |
| median | 31977 |
| Q3 | 39605 |
| 95-th percentile | 46326 |
| Maximum | 47919 |
| Range | 47837 |
| Interquartile range (IQR) | 17360 |
Descriptive statistics
| Standard deviation | 12697.61 |
|---|---|
| Coefficient of variation (CV) | 0.43200463 |
| Kurtosis | -0.57952081 |
| Mean | 29392.301 |
| Median Absolute Deviation (MAD) | 8521 |
| Skewness | -0.57511919 |
| Sum | 2.6248207 × 109 |
| Variance | 1.6122931 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21363 | 100 | 0.1% |
| 41181 | 100 | 0.1% |
| 1106 | 100 | 0.1% |
| 23658 | 100 | 0.1% |
| 40684 | 100 | 0.1% |
| 11197 | 100 | 0.1% |
| 41042 | 100 | 0.1% |
| 26720 | 100 | 0.1% |
| 37035 | 100 | 0.1% |
| 38229 | 100 | 0.1% |
| Other values (1677) | 88303 |
| Value | Count | Frequency (%) |
| 82 | 34 | < 0.1% |
| 281 | 65 | |
| 407 | 36 | |
| 412 | 85 | |
| 416 | 40 | |
| 472 | 81 | |
| 485 | 3 | < 0.1% |
| 491 | 77 | |
| 584 | 34 | < 0.1% |
| 590 | 36 |
| Value | Count | Frequency (%) |
| 47919 | 36 | |
| 47847 | 45 | |
| 47819 | 49 | |
| 47788 | 60 | |
| 47777 | 7 | < 0.1% |
| 47775 | 74 | |
| 47750 | 43 | |
| 47748 | 64 | |
| 47746 | 49 | |
| 47717 | 52 |
hora
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.84921 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 124 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 20 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.0668964 |
|---|---|
| Coefficient of variation (CV) | 0.29365548 |
| Kurtosis | -0.69829258 |
| Mean | 13.84921 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.17954762 |
| Sum | 1236776 |
| Variance | 16.539646 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 8422 | |
| 12 | 7934 | 8.9% |
| 17 | 7912 | 8.9% |
| 13 | 7355 | 8.2% |
| 11 | 6757 | 7.6% |
| 19 | 6455 | 7.2% |
| 16 | 6234 | 7.0% |
| 10 | 6177 | 6.9% |
| 14 | 5933 | 6.6% |
| 15 | 5506 | 6.2% |
| Other values (14) | 20618 |
| Value | Count | Frequency (%) |
| 0 | 124 | 0.1% |
| 1 | 101 | 0.1% |
| 2 | 72 | 0.1% |
| 3 | 70 | 0.1% |
| 4 | 129 | 0.1% |
| 5 | 367 | 0.4% |
| 6 | 1526 | 1.7% |
| 7 | 2886 | |
| 8 | 4132 | |
| 9 | 5183 |
| Value | Count | Frequency (%) |
| 23 | 255 | 0.3% |
| 22 | 508 | 0.6% |
| 21 | 1507 | 1.7% |
| 20 | 3758 | |
| 19 | 6455 | |
| 18 | 8422 | |
| 17 | 7912 | |
| 16 | 6234 | |
| 15 | 5506 | |
| 14 | 5933 |
PAIS_ORIGEN
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.957661 |
| Minimum | 2 |
|---|---|
| Maximum | 49 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 37 |
| median | 37 |
| Q3 | 37 |
| 95-th percentile | 37 |
| Maximum | 49 |
| Range | 47 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.2048893 |
|---|---|
| Coefficient of variation (CV) | 0.032601882 |
| Kurtosis | 504.14909 |
| Mean | 36.957661 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -19.133389 |
| Sum | 3300430 |
| Variance | 1.4517583 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37 | 88834 | |
| 22 | 195 | 0.2% |
| 40 | 92 | 0.1% |
| 49 | 76 | 0.1% |
| 2 | 50 | 0.1% |
| 41 | 34 | < 0.1% |
| 9 | 15 | < 0.1% |
| 35 | 3 | < 0.1% |
| 43 | 3 | < 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 50 | 0.1% |
| 9 | 15 | < 0.1% |
| 15 | 1 | < 0.1% |
| 22 | 195 | 0.2% |
| 35 | 3 | < 0.1% |
| 37 | 88834 | |
| 40 | 92 | 0.1% |
| 41 | 34 | < 0.1% |
| 43 | 3 | < 0.1% |
| 49 | 76 | 0.1% |
| Value | Count | Frequency (%) |
| 49 | 76 | 0.1% |
| 43 | 3 | < 0.1% |
| 41 | 34 | < 0.1% |
| 40 | 92 | 0.1% |
| 37 | 88834 | |
| 35 | 3 | < 0.1% |
| 22 | 195 | 0.2% |
| 15 | 1 | < 0.1% |
| 9 | 15 | < 0.1% |
| 2 | 50 | 0.1% |
COD_MONEDA_ORIGEN
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.568637 |
| Minimum | 1 |
|---|---|
| Maximum | 34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 29 |
| median | 29 |
| Q3 | 29 |
| 95-th percentile | 29 |
| Maximum | 34 |
| Range | 33 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.0894031 |
|---|---|
| Coefficient of variation (CV) | 0.10813967 |
| Kurtosis | 49.466997 |
| Mean | 28.568637 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -7.1254993 |
| Sum | 2551265 |
| Variance | 9.5444115 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29 | 87417 | |
| 6 | 1530 | 1.7% |
| 19 | 165 | 0.2% |
| 23 | 89 | 0.1% |
| 34 | 49 | 0.1% |
| 1 | 49 | 0.1% |
| 27 | 3 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 49 | 0.1% |
| 6 | 1530 | 1.7% |
| 14 | 1 | < 0.1% |
| 19 | 165 | 0.2% |
| 23 | 89 | 0.1% |
| 27 | 3 | < 0.1% |
| 29 | 87417 | |
| 34 | 49 | 0.1% |
| Value | Count | Frequency (%) |
| 34 | 49 | 0.1% |
| 29 | 87417 | |
| 27 | 3 | < 0.1% |
| 23 | 89 | 0.1% |
| 19 | 165 | 0.2% |
| 14 | 1 | < 0.1% |
| 6 | 1530 | 1.7% |
| 1 | 49 | 0.1% |
COD_PROD_EMISOR
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2657917 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 3.3591822 |
|---|---|
| Coefficient of variation (CV) | 0.63792539 |
| Kurtosis | -1.4449814 |
| Mean | 5.2657917 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.53912939 |
| Sum | 470251 |
| Variance | 11.284105 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 31220 | |
| 10 | 27933 | |
| 4 | 25779 | |
| 6 | 1734 | 1.9% |
| 7 | 1308 | 1.5% |
| 5 | 943 | 1.1% |
| 3 | 352 | 0.4% |
| 1 | 34 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 34 | < 0.1% |
| 2 | 31220 | |
| 3 | 352 | 0.4% |
| 4 | 25779 | |
| 5 | 943 | 1.1% |
| 6 | 1734 | 1.9% |
| 7 | 1308 | 1.5% |
| 10 | 27933 |
| Value | Count | Frequency (%) |
| 10 | 27933 | |
| 7 | 1308 | 1.5% |
| 6 | 1734 | 1.9% |
| 5 | 943 | 1.1% |
| 4 | 25779 | |
| 3 | 352 | 0.4% |
| 2 | 31220 | |
| 1 | 34 | < 0.1% |
TIP_NEGOCIO
Real number (ℝ)
| Distinct | 2968 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2612.0245 |
| Minimum | 1 |
|---|---|
| Maximum | 5699 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 244 |
| Q1 | 1477 |
| median | 2793 |
| Q3 | 3960 |
| 95-th percentile | 4632 |
| Maximum | 5699 |
| Range | 5698 |
| Interquartile range (IQR) | 2483 |
Descriptive statistics
| Standard deviation | 1476.1176 |
|---|---|
| Coefficient of variation (CV) | 0.56512396 |
| Kurtosis | -1.155583 |
| Mean | 2612.0245 |
| Median Absolute Deviation (MAD) | 1195 |
| Skewness | -0.19830225 |
| Sum | 2.3326162 × 108 |
| Variance | 2178923.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3988 | 3760 | 4.2% |
| 123 | 1033 | 1.2% |
| 4225 | 896 | 1.0% |
| 4007 | 831 | 0.9% |
| 4011 | 710 | 0.8% |
| 946 | 676 | 0.8% |
| 4012 | 673 | 0.8% |
| 4010 | 504 | 0.6% |
| 3783 | 361 | 0.4% |
| 4009 | 307 | 0.3% |
| Other values (2958) | 79552 |
| Value | Count | Frequency (%) |
| 1 | 13 | < 0.1% |
| 4 | 19 | < 0.1% |
| 5 | 53 | |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 16 | 77 | |
| 19 | 24 | < 0.1% |
| 21 | 98 | |
| 23 | 18 | < 0.1% |
| 24 | 58 |
| Value | Count | Frequency (%) |
| 5699 | 48 | 0.1% |
| 5648 | 4 | < 0.1% |
| 5647 | 164 | |
| 5640 | 46 | 0.1% |
| 5506 | 9 | < 0.1% |
| 5486 | 13 | < 0.1% |
| 5485 | 24 | < 0.1% |
| 5462 | 11 | < 0.1% |
| 5461 | 5 | < 0.1% |
| 5456 | 1 | < 0.1% |
IND_ESTADO_INACTIVA
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 89303 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 89303 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 89303 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 89303 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89303 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 89303 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 89303 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 89303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89303 |
PORC_RETIRO
Real number (ℝ)
| Distinct | 4838 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.63618 |
| Minimum | 0 |
|---|---|
| Maximum | 200000 |
| Zeros | 740 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.02 |
| Q1 | 0.1 |
| median | 0.3 |
| Q3 | 0.95 |
| 95-th percentile | 81.498 |
| Maximum | 200000 |
| Range | 200000 |
| Interquartile range (IQR) | 0.85 |
Descriptive statistics
| Standard deviation | 2441.9561 |
|---|---|
| Coefficient of variation (CV) | 20.936524 |
| Kurtosis | 3597.1573 |
| Mean | 116.63618 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 53.046062 |
| Sum | 10415961 |
| Variance | 5963149.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2932 | 3.3% |
| 0.03 | 2618 | 2.9% |
| 0.05 | 2570 | 2.9% |
| 0.02 | 2566 | 2.9% |
| 0.04 | 2472 | 2.8% |
| 0.06 | 2295 | 2.6% |
| 0.01 | 2279 | 2.6% |
| 0.07 | 2212 | 2.5% |
| 0.08 | 1910 | 2.1% |
| 0.1 | 1877 | 2.1% |
| Other values (4828) | 65572 |
| Value | Count | Frequency (%) |
| 0 | 740 | 0.8% |
| 0.01 | 2279 | |
| 0.02 | 2566 | |
| 0.03 | 2618 | |
| 0.04 | 2472 | |
| 0.05 | 2570 | |
| 0.06 | 2295 | |
| 0.07 | 2212 | |
| 0.08 | 1910 | |
| 0.09 | 1844 |
| Value | Count | Frequency (%) |
| 200000 | 6 | < 0.1% |
| 110000 | 1 | < 0.1% |
| 100000 | 14 | |
| 90000 | 1 | < 0.1% |
| 80000 | 1 | < 0.1% |
| 70000 | 1 | < 0.1% |
| 66666.67 | 2 | < 0.1% |
| 50000 | 17 | |
| 40000 | 3 | < 0.1% |
| 36000 | 1 | < 0.1% |
CNT_CUENTAS_DISTINTAS
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 2 | 605 |
| 3 | 3 |
| 4 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 89303 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 89303 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 89303 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 89303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 88694 | |
| 2 | 605 | 0.7% |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
IND_DEBAJO_UMBRAL_15K
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 3124 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 89303 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 89303 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 89303 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 89303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 86179 | |
| 1 | 3124 | 3.5% |
IND_SUP_15K
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 | |
|---|---|
| 1 | 225 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 89303 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 89303 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 89303 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 89303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89078 | |
| 1 | 225 | 0.3% |
CNT_RETIRO_CUENTA
Real number (ℝ)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.179714 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.47459913 |
|---|---|
| Coefficient of variation (CV) | 0.40230016 |
| Kurtosis | 51.22125 |
| Mean | 1.179714 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.3952333 |
| Sum | 105352 |
| Variance | 0.22524434 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 75652 | |
| 2 | 11791 | 13.2% |
| 3 | 1505 | 1.7% |
| 4 | 276 | 0.3% |
| 5 | 49 | 0.1% |
| 6 | 10 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Other values (6) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 75652 | |
| 2 | 11791 | 13.2% |
| 3 | 1505 | 1.7% |
| 4 | 276 | 0.3% |
| 5 | 49 | 0.1% |
| 6 | 10 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 16 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 8 | 5 | |
| 7 | 5 |
CNT_CAJEROS_DISTINTOS
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 2 | 6663 |
| 3 | 384 |
| 4 | 26 |
| 5 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 89303 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 89303 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 89303 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 89303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 82228 | |
| 2 | 6663 | 7.5% |
| 3 | 384 | 0.4% |
| 4 | 26 | < 0.1% |
| 5 | 2 | < 0.1% |
| NUM_AUTORIZACION_TC | MON_MOVIMIENTO_QUETZALIZADO | NUM_CTA_DEB | hora | PAIS_ORIGEN | COD_MONEDA_ORIGEN | COD_PROD_EMISOR | TIP_NEGOCIO | IND_ESTADO_INACTIVA | PORC_RETIRO | CNT_CUENTAS_DISTINTAS | IND_DEBAJO_UMBRAL_15K | IND_SUP_15K | CNT_RETIRO_CUENTA | CNT_CAJEROS_DISTINTOS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COD_CLIENTE | |||||||||||||||
| 14797 | 543641 | 1000.0 | 45658 | 19 | 37 | 29 | 2 | 4421 | 0 | 0.14 | 2 | 0 | 0 | 1 | 2 |
| 27977 | 507481 | 1400.0 | 12226 | 18 | 37 | 29 | 10 | 4011 | 0 | 0.23 | 1 | 0 | 0 | 1 | 1 |
| 11304 | 138648 | 1000.0 | 34808 | 18 | 37 | 29 | 2 | 3954 | 0 | 1.00 | 1 | 0 | 0 | 1 | 1 |
| 28721 | 732668 | 100.0 | 1320 | 12 | 37 | 29 | 7 | 578 | 0 | 0.07 | 1 | 0 | 0 | 1 | 1 |
| 17782 | 346667 | 100.0 | 1838 | 18 | 37 | 29 | 4 | 1610 | 0 | 0.02 | 1 | 0 | 0 | 2 | 2 |
| 42102 | 688024 | 200.0 | 9886 | 18 | 37 | 29 | 2 | 4007 | 0 | 0.28 | 1 | 0 | 0 | 1 | 1 |
| 18570 | 695361 | 200.0 | 38833 | 13 | 37 | 29 | 4 | 3783 | 0 | 0.76 | 1 | 0 | 0 | 1 | 1 |
| 42867 | 347429 | 200.0 | 32471 | 7 | 37 | 29 | 2 | 1597 | 0 | 0.04 | 1 | 0 | 0 | 1 | 1 |
| 7749 | 265875 | 200.0 | 32333 | 17 | 37 | 29 | 2 | 1987 | 0 | 0.30 | 1 | 0 | 0 | 1 | 1 |
| 38910 | 269341 | 400.0 | 26597 | 16 | 37 | 29 | 4 | 3988 | 0 | 0.93 | 1 | 0 | 0 | 1 | 1 |
| NUM_AUTORIZACION_TC | MON_MOVIMIENTO_QUETZALIZADO | NUM_CTA_DEB | hora | PAIS_ORIGEN | COD_MONEDA_ORIGEN | COD_PROD_EMISOR | TIP_NEGOCIO | IND_ESTADO_INACTIVA | PORC_RETIRO | CNT_CUENTAS_DISTINTAS | IND_DEBAJO_UMBRAL_15K | IND_SUP_15K | CNT_RETIRO_CUENTA | CNT_CAJEROS_DISTINTOS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COD_CLIENTE | |||||||||||||||
| 14260 | 388800 | 1000.0 | 634 | 15 | 37 | 29 | 10 | 2771 | 0 | 0.17 | 1 | 0 | 0 | 2 | 1 |
| 18370 | 239730 | 100.0 | 18679 | 0 | 37 | 29 | 4 | 2855 | 0 | 0.03 | 1 | 0 | 0 | 1 | 1 |
| 21005 | 577850 | 100.0 | 40068 | 8 | 37 | 29 | 4 | 618 | 0 | 0.89 | 1 | 0 | 0 | 1 | 1 |
| 39131 | 675190 | 1000.0 | 46177 | 17 | 37 | 29 | 10 | 4048 | 0 | 0.13 | 1 | 0 | 0 | 1 | 1 |
| 16516 | 62905 | 1000.0 | 37774 | 14 | 37 | 29 | 10 | 2986 | 0 | 0.88 | 1 | 0 | 0 | 1 | 1 |
| 12536 | 454720 | 100.0 | 43462 | 13 | 37 | 29 | 2 | 1649 | 0 | 0.49 | 1 | 0 | 0 | 1 | 1 |
| 21021 | 487170 | 200.0 | 40085 | 6 | 37 | 29 | 10 | 641 | 0 | 0.56 | 1 | 0 | 0 | 1 | 1 |
| 43877 | 122060 | 100.0 | 20521 | 12 | 37 | 29 | 10 | 188 | 0 | 0.01 | 1 | 0 | 0 | 1 | 1 |
| 44610 | 495710 | 100.0 | 39095 | 18 | 37 | 29 | 10 | 3408 | 0 | 0.71 | 1 | 0 | 0 | 1 | 1 |
| 8433 | 3149 | 300.0 | 32927 | 15 | 37 | 29 | 2 | 3303 | 0 | 0.20 | 1 | 0 | 0 | 2 | 1 |